SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.DnnProduct_SR_SQL_UpdateReport
(
	@ReportID int,
	@ModuleID int,
	@ReportName nvarchar(50),
	@Description nvarchar(250),
	@ReportDefinition text,
	@ReportHeader nvarchar(3000),
	@ReportFooter nvarchar(3000),
	@ConnectionID int,
	@RestrictViewing bit,
	@HtmlEncode bit,
	@AutoExecute bit,
	@HideHeader bit	
)
as
BEGIN
	UPDATE dbo.DnnProduct_SR_SQL_Reports  
	
	SET ReportName = @ReportName,  
	Description = @Description,
	ReportDefinition = @ReportDefinition, 
	ReportHeader = @ReportHeader, 
	ReportFooter = @ReportFooter,
	ConnectionID = @ConnectionID,
	RestrictViewing = @RestrictViewing,
	HtmlEncode = @HtmlEncode,
	AutoExecute = @AutoExecute,
	HideHeader = @HideHeader

	WHERE ReportID = @ReportID
	AND ModuleID = @ModuleID
END
GO
